/*    */ package com.yc.dao.export;
/*    */ 
/*    */ import btsm.bean.dbConnector;
/*    */ import com.yc.dao.model.AcdcDistributionBO;
/*    */ import com.yc.util.FormateSQL;
/*    */ import java.sql.ResultSet;
/*    */ import java.util.ArrayList;
/*    */ import java.util.List;
/*    */ import org.apache.commons.logging.Log;
/*    */ import org.apache.commons.logging.LogFactory;
/*    */ 
/*    */ public class AcdcDistributionExportDAO
/*    */   implements IExportAll
/*    */ {
/* 17 */   private static final Log log = LogFactory.getLog(AcdcDistributionExportDAO.class);
/*    */ 
/*    */   public List export(dbConnector dbcon, String strBtsName, String strRegistBeginTime, String strRegistEndTime) {
/* 20 */     ResultSet rs = null;
/* 21 */     List list = new ArrayList();
/*    */     try
/*    */     {
/* 24 */       String strSQL = " select * from acdcdistribution where btsname like '%" + strBtsName + "%'";
/* 25 */       strSQL = FormateSQL.getFormateSQL(strRegistBeginTime, strRegistEndTime, strSQL);
/* 26 */       log.info(strSQL);
/* 27 */       rs = dbcon.execQuery(strSQL);
/* 28 */       while (rs.next()) {
/* 29 */         AcdcDistributionBO bo = new AcdcDistributionBO();
/* 30 */         bo.setId(rs.getString("id"));
/* 31 */         bo.setBtscode(rs.getString("btscode"));
/* 32 */         bo.setBtsname(rs.getString("btsname"));
/* 33 */         bo.setDistmanufacturer(rs.getString("distmanufacturer"));
/* 34 */         bo.setDisttype(rs.getString("disttype"));
/* 35 */         bo.setDistother(rs.getString("distother"));
/* 36 */         bo.setAirswitchM(rs.getString("airswitchM"));
/* 37 */         bo.setAirswitchT(rs.getString("airswitchT"));
/* 38 */         bo.setAirswitchC(rs.getString("airswitchC"));
/* 39 */         bo.setAirswitchO(rs.getString("airswitchO"));
/* 40 */         bo.setAirswitchCRD(rs.getString("airswitchCRD"));
/* 41 */         bo.setElecableDAS(rs.getString("elecableDAS"));
/* 42 */         bo.setElecableDAT(rs.getString("elecableDAT"));
/* 43 */         bo.setElecableDANum(rs.getString("elecableDANum"));
/* 44 */         bo.setElecableDALen(rs.getString("elecableDALen"));
/* 45 */         bo.setElecableDACRD(rs.getString("elecableDACRD"));
/* 46 */         bo.setRegulatorM(rs.getString("regulatorM"));
/* 47 */         bo.setRegulatorT(rs.getString("regulatorT"));
/* 48 */         bo.setRegulatorC(rs.getString("regulatorC"));
/* 49 */         bo.setRegulatorOT(rs.getDate("regulatorOT"));
/* 50 */         bo.setRegulatorCRD(rs.getString("regulatorCRD"));
/* 51 */         bo.setLighting(rs.getString("lighting"));
/* 52 */         bo.setSocket(rs.getString("socket"));
/* 53 */         bo.setElecableCPS(rs.getString("elecableCPS"));
/* 54 */         bo.setElecableCPT(rs.getString("elecableCPT"));
/* 55 */         bo.setElecableCPNum(rs.getString("elecableCPNum"));
/* 56 */         bo.setElecableCPLen(rs.getString("elecableCPLen"));
/* 57 */         bo.setElecableCPCRD(rs.getString("elecableCPCRD"));
/* 58 */         bo.setDDConverterT(rs.getString("DDConverterT"));
/* 59 */         bo.setDDConverterM(rs.getString("DDConverterM"));
/* 60 */         bo.setDDConverterNum(rs.getString("DDConverterNum"));
/* 61 */         bo.setDDConverterC(rs.getString("DDConverterC"));
/* 62 */         bo.setDDConverterOT(rs.getDate("DDConverterOT"));
/* 63 */         bo.setDDConverterCRD(rs.getString("DDConverterCRD"));
/* 64 */         bo.setDDisplayT(rs.getString("DDisplayT"));
/* 65 */         bo.setDDisplayM(rs.getString("DDisplayM"));
/* 66 */         bo.setDDisplayNum(rs.getString("DDisplayNum"));
/* 67 */         bo.setDDisplayC(rs.getString("DDisplayC"));
/* 68 */         bo.setDDisplayOT(rs.getDate("DDisplayOT"));
/* 69 */         bo.setMaintenance(rs.getString("maintenance"));
/* 70 */         bo.setRefreshtime(rs.getDate("refreshtime"));
/* 71 */         bo.setMemo(rs.getString("memo"));
/* 72 */         list.add(bo);
/*    */       }
/*    */     }
/*    */     catch (Exception e) {
/* 76 */       e.printStackTrace();
/* 77 */       log.error(e.getMessage());
/*    */     }
/* 79 */     return list;
/*    */   }
/*    */ }

/* Location:           E:\java\apache-tomcat-6.0.36\webapps\btsm\WEB-INF\classes\
 * Qualified Name:     com.yc.dao.export.AcdcDistributionExportDAO
 * JD-Core Version:    0.6.2
 */